<?php
namespace app\run\model;

use think\Model;
use think\Db;
class Subscribe extends Model{
	//查询预约列表
	public static function subscribe_sel(){
		 return Db::name('subscribe')->alias('a')
		 ->join('product b','a.goods_id=b.id')
		 ->where('a.result','neq',2)
		 ->where('a.result','neq',3)
		 ->field('a.*,b.name')
		 ->select()->toArray();
		
	}
	//查询车系参数
	public static function subscribe_sel_name($gid){
		 return Db::name('product') 
		 ->field('goods_model,name,goods_describe,goods_car,goods_model_car,goods_price,goods_payment,goods_month')
		 ->where('id',$gid)
		 ->find();
		
	}
 
}